基础sql语句

从数据库中删除数据 delete 
插入数据 insert into
创建新数据库 create database
修改数据库  alter database
创建新表    create table
变更数据库表 alter table
删除表 drop table
创建索引     create index
删除索引     drop index
查找所有列   select * from table
查找列中不同值 select distinct name from table
select * from table where city = 'beijing'
order by 字段名 默认升序(desc 降序)
update person set address = 'zhengzhou', city = 'beijing' where lastName =  'xiaocao'
delete from person where lastName = 'xiaocao'
select * from persons where lastName in('adms','carter');
select column_name(s) from table_name where column_name between value1 and value2